Copy Code code as follows:
Set WshShell = WScript.CreateObject ("Wscript.Shell")
' dialog box title
Alerttitle = "Timed Reminder"
' Reminder content, vbnewline as line break
Alerttext = vbnewline vbNewLine "Take a break, move your arms, your neck, your waist." " vbNewLine
parameter transmitted by the DDE ProgramCase "Max"Me. windowstate = 2Info = info + vbnewline + "The form has been maximized"Case "Showtime"Info = info + vbnewline + "the last time this program was run:" + STR (now)Case "count"Lngcount = lngcount + 1Info = info + vbnewline + "you have already called this program again" + STR (lngcount) +. "_+
constantPrivate Sub Form_linkexecute (cmdstr as String, Cancel as Integer)Static Lngcount as LongDim Info as Stringinfo = Txtinfo.text Note: Keep original informationSelect Case CMDSTR Note: CMDSTR is a parameter that the DDE program transmits.Case "Max."Me.windowstate = 2info = info + vbnewline + "form has been maximized"Case "ShowTime"info = info + vbnewline + "The last time you run this program is:" + S
ClassMyApplication'One of the global exceptions we caught is not thread safe, so we need to make it thread safe first. Private Delegate SubSafeapplicationthreadexception (ByValSender as Object,ByValE asThreading.threadexceptioneventargs)Private SubShowdebugoutput (ByValEx asException)'Show output error from form DimFrmd as NewForm2 ()'Display Solution NameFrmD.TextBox1.AppendText ("Product Name:" My.Application.Info.ProductName vbnewline
record learning answers Dim lasta As String ' to determine the answer to the previous question Dim cmdlist As New ArrayList ' load predefined command list public istalkwithsound As Boolean the variable public issoundrecognition as Boolean ' used to determine whether speech-reading is enabled is used to determine whether speech recognition is enabled for variable public ismsgwithsound as Boolea
N ' is used to determine whether to turn on message beep Dim point as ' Move for form ' dialo
Item = Application (Key)
Item (0) = 0
Application (Key) = Item
End IF
Next
Application.Lock
End Sub
' Delete a cache
Public Sub Clear (ByRef Key)
Application.Contents.Remove (PREFIX Key)
End Sub
' Empty the unused cache
Public Sub clearunused ()
Dim Key, Keys, Keylength, KeyIndex
For each Key in application.contents
IF (Left (Key, prefix_length) = PREFIX) Then
IF (Application (Key) (0) = 0) Then
Keys = keys vbNewLine Key
End IF
the Help FileCtxt = 1000 'defines the help topicResponse = msgbox (MSG, style, title, help, ctxt)If response = vbyes then 'user presses "yes"Mystring = "yes" 'to complete an operationElse 'user presses "no"Mystring = "no" 'to complete an operationEnd if(2) only display a messageMsgbox "Hello !"(3) Assign the result returned by the message box to the variableAns = msgbox ("Continue ?", Vbyesno)If msgbox ("continue ?", Vbyesno) (4) use a combination of constants, assign values to the config varia
cache and can be directly read from XMLReaddatafromxmlM_readon = 2ElseReaddatafromdbM_readon = 1End ifEnd Function
REM writes XML data Public Function writedatatoxml If fsoexistsfile (m_xmlfile) then' exit directly if the XML has not expired if not isxmlcacheexpired (m_xmlfile, m_cachetime) then exit function end if dim RS dim xmlcontent dim k xmlcontent = "" xmlcontent = xmlcontent "
" Vbnewline xmlcontent = xmlcontent "
"
Download the workbook online, found that there is a password!xxoo, since put on the Internet why to add a password ah?! Later on the internet to find a way to use VBA to crack the worksheet password, to share.
First, when you try to open the workbook, you are prompted with a password:
Using the shortcut key ctrl+f11, open the VBA editing interface and tap the submenu "module" under the "Insert" menu:
Enter the following code in the module editor:
Option Explicit
Publ
passwords not original passwords Cons T dblspace As String = vbnewline amp; vbNewLine Const AUTHORS As String = Dblspace amp; vbNewLine amp; _ "adapted from Bob McCormick Base Code by "amp; _" Norman Harker and JE McGimpsey "Const HEADER as String =" Allinternalpasswords User M Essage "Const version As String = Dblspace amp;" Version 1.1.1 2003-apr-04 "Const rep
''''''''''''''''''''
adOpenStatic = 3
adLockOptimistic = 3
'''''''''''''''''''''''''''
' Declare Global Variables
'''''''''''''''''''''''''''
DIM Con
SUB Readydbcon
IF Con = "" THEN
Set Con = Server.CreateObject ("ADODB.") Connection ")
Con.open "Provider=microsoft. JET. Oledb.4.0;data source= " DBPath
End IF
End SUB
FUNCTION Showuser (Theemail)
Wherea = INSTR (Theemail, "@")
Showuser = Server.HTMLEncode (left (Theemail, whereA-1))
End FUNCTION
FUNCTION Formatoutput (thetext)
TheText
not original passwords Cons T dblspace As String = vbnewline vbNewLine Const AUTHORS As String = Dblspace vbNewLine _ "adapted from Bob McCormick Base Code by " _" Norman Harker and JE McGimpsey "Const HEADER as String =" Allinternalpasswords User M Essage "Const version As String = Dblspace " Version 1.1.1 2003-apr-04 "Const repback As String = Dblspace " Pl
Compile
Code The property definition is often generated based on the defined private variables. This operation can be implemented using the Vs. Net macro, the Code is as follows:
Sub temporarymacro ()
Sub Temporarymacro () Dim TS As Textselection = DTE. activedocument. Selection Dim Insertion As String , Line As String Dim Lines () As String = TS. Text. Split (vbnewline) ' Returns the attribute process for each row of
, Style, Title, help, Ctxt)If Response = vbyes Then ' user presses ' yes 'MyString = "Yes" to complete an operationElse ' user pressed ' no 'MyString = "No" completes an operationEnd If(2) Show only a messageMsgBox "Hello!"(3) Assigning the result of a message box to a variableAns=msgbox ("Continue?", vbYesNo)If MsgBox ("Continue?", vbYesNo) (4) Use a combination of constants, assign a group config variable, and set the second button as the default buttonConfig=vbyesno+vbquestion+vbdefaultbutton
!! Find AH find ah ah.
The implementation code is as follows:
VB Code:
Copy Code code as follows:
Set fso = CreateObject ("Scripting.FileSystemObject")
Set File=fso.opentextfile ("1.txt")
TS = File.readall
File.close
Set fil = Fso.createtextfile ("2.txt")
Ts=replace (TS, "Value _", "a")
Ts=replace (TS, "Occurrence frequency", "=")
"If there is a horizontal line and a blank row, plus this, no comment out
Ts=replace (ts, "-----------------------" +
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.